CREATE TABLE [dbo].[tablename] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[url] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[con] [text] COLLATE Chinese_PRC_CI_AS NULL ,
        [kuaizhao] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[tit] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
        [pr] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[dt] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


ALTER TABLE [dbo].[tablename] WITH NOCHECK ADD 
	CONSTRAINT [PK_tablename] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 


ALTER TABLE [dbo].[tablename] WITH NOCHECK ADD 
	CONSTRAINT [DF_tablename_dt] DEFAULT (getdate()) FOR [dt]


if (select DATABASEPROPERTY(DB_NAME(), N'IsFullTextEnabled')) <> 1 
exec sp_fulltext_database N'enable' 

if not exists (select * from dbo.sysfulltextcatalogs where name = N'indexname')
exec sp_fulltext_catalog N'indexname', N'create' ,N'pathname'



exec sp_fulltext_table N'[dbo].[tablename]', N'create', N'indexname', N'PK_tablename'


exec sp_fulltext_column N'[dbo].[tablename]', N'con', N'add', 2052  


exec sp_fulltext_table N'[dbo].[tablename]', N'activate'

